if exists (select 1
            from  sysobjects
           where  id = object_id('lr_jiaba')
            and   type = 'U')
   drop table lr_jiaba
go

/*==============================================================*/
/* Table: lr_jiaba                                              */
/*==============================================================*/
CREATE TABLE dbo.lr_jiaba (
  user_serial int NOT NULL,
  bh smallint NULL,
  kssj smalldatetime NOT NULL,
  jssj smalldatetime NOT NULL,
  jsjg int NULL,
  bz text NULL,
  gly_no nvarchar(10) NULL,
  shenhe nvarchar(10) NULL,
  lx int NULL,
  jbrq datetime NULL,
  img_path varchar(500) NULL,
  order_id int NOT NULL,
  ot_begin int NOT NULL CONSTRAINT DF__lr_jiaba__ot_beg__42C2BEC4 DEFAULT (0),
  ot_end int NOT NULL CONSTRAINT DF__lr_jiaba__ot_end__43B6E2FD DEFAULT (0),
  over_time_type_id int NOT NULL CONSTRAINT DF__lr_jiaba__over_t__44AB0736 DEFAULT (0),
  is_repast int NOT NULL CONSTRAINT DF__lr_jiaba__is_rep__459F2B6F DEFAULT (0),
  shift_id int NOT NULL CONSTRAINT DF__lr_jiaba__shift___46934FA8 DEFAULT (0),
  is_delete int NOT NULL CONSTRAINT DF__lr_jiaba__is_del__478773E1 DEFAULT (0),
  remove_user varchar(64) NULL,
  remove_time datetime NULL,
  return_remark varchar(2000) NULL,
  id int IDENTITY,
  settle_year int NULL DEFAULT (0),
  settle_month int NULL DEFAULT (0),
  CONSTRAINT PK_lr_jiaba PRIMARY KEY CLUSTERED (id)
)
go
